ALTER DATABASE Di_local
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (DI_Local_log, 2048);
GO
-- Reset the database recovery model.
ALTER DATABASE Di_local
SET RECOVERY FULL;
GO

Use DBMoto_Local

ALTER DATABASE DBMoto_Local
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (DBMoto_Local_log, 2048);
GO
-- Reset the database recovery model.
ALTER DATABASE DBMoto_Local
SET RECOVERY FULL;
GO



Use RD_Common

ALTER DATABASE RD_Common
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (RD_COMMON_log, 2048);
GO



sp_helpfile